CREATE VIEW [dbo].[vSoaItemEvent]
WITH SCHEMABINDING
AS
    SELECT  'EVENT-' + [m].[MEETING] AS [ItemId],
            'EVENT-' + [m].[MEETING] AS [ProductCode],
            [m].[TITLE] AS [Name],
            CAST(NULL  AS VARCHAR(MAX)) AS [Description], -- can't have text in indexed view. we can add this back below if we need to.
            CAST(NULL AS VARCHAR(50)) AS [TaxCategory],
            'EVENT' AS [ItemClass],
            [m].[MEETING_URL] AS [ImageURL]
      FROM  [dbo].[Meet_Master] AS [m]

GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaItemEvent] ON [dbo].[vSoaItemEvent] ([ItemId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaItemEvent] ON [dbo].[vSoaItemEvent] ([ProductCode]) ON [PRIMARY]
GO